﻿CREATE TABLE [trUser].[tblCompanyContacts] (
    [IDCompanyContact] BIGINT        IDENTITY (1, 1) NOT NULL,
    [IDCompany]        BIGINT        NOT NULL,
    [IDContactType]    BIGINT        NOT NULL,
    [Contact]          NVARCHAR (50) NOT NULL,
    [DateCreated]      DATETIME      CONSTRAINT [DF_tblCompanyContacts_DateCreated] DEFAULT (getdate()) NOT NULL,
    [DateUpdated]      DATETIME      NULL,
    [DateInactive]     DATETIME      NULL,
    CONSTRAINT [PK_tblCompanyContacts] PRIMARY KEY CLUSTERED ([IDCompanyContact] ASC)
);

